advantages and disadvantages

Advantages of DBMS:

 

Data independence:

  1. Application programs should be as independent as possible from details of data representation and storage.
  2. The DBMS can provide an abstract view of the data to insulate application code from such details.

 

Efficient data access:

  1. A DBMS utilizes a variety of sophisticated techniques to store and retrieve data efficiently.
  2. This feature is especially important if the data is stored on external storage devices.

 

 

Data integrity and security:

  1. If data is always accessed through the DBMS, the DBMS can enforce integrity constraints on the data.
  2. For example, before inserting salary information for an employee, the DBMS can check that the department budget is not exceeded.
  3. Also, the DBMS can enforce access controls that govern what data is visible to different classes of users.

 

 

Data administration:

    1. When several users share the data, centralizing the administration of data can offer significant improvements.
    2. Experienced professionals who understand the nature of the data being managed, and how different groups of users use it, can be responsible for organizing the data representation to minimize redundancy and fine-tuning the storage of the data to make retrieval efficient.

 

 

 

DBMS & SQl by P. Muthulakshmi & v. vanthana